
<%@page import="jobportal.Dbconn"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%-- 
    Document   : editresume
    Created on : Apr 5, 2012, 6:54:44 PM
    Author     : Ajay Kumar "Mukund"
--%>
<%@include file="header.jsp" %>
<%try {
                Connection con = null;
                Statement st = null, st1 = null;
                ResultSet rs = null, rs1 = null;
                int maxedu = 0;
                String username = (String) session.getAttribute("username");
                String res_title = "", res_keyskill = "", resume_text = "";
                String resumetitle = "", name = "", gender = "", dob = "", nationality = "", address = "", city = "", state = "", pin = "", contact = "", email = "";
                String employer = "", industry = "", role = "", salary = "0", exp = "0";
                String des_industry = "", des_fun_area = "", des_keyskill = "", des_salary = "";
                String course10 = "", course12 = "", courseug = "", coursepg = "";
                String uni10 = "", uni12 = "", uniug = "", unipg = "";
                String stream10 = "", stream12 = "", streamug = "", streampg = "";
                String year10 = "", year12 = "", yearug = "", yearpg = "";
                String mark10 = "", mark12 = "", markug = "", markpg = "";
                try {
                    con = Dbconn.getConn();
                    st = con.createStatement();
                    st1 = con.createStatement();
                    String sql = "select * from student where username='" + username + "'";
                    rs = st.executeQuery(sql);
                    if (rs.next()) {
                        name = rs.getString("name");
                        gender = rs.getString("gender");
                        dob = rs.getString("dob");
                        address = rs.getString("address");
                        email = rs.getString("email");
                        city = rs.getString("city");
                        state = rs.getString("state");
                        pin = rs.getString("pin");
                        contact = rs.getString("contact");
                        nationality = rs.getString("nationality");
                    }
                    sql = "select * from exprience where username='" + username + "'";
                    rs = st.executeQuery(sql);
                    if (rs.next()) {
                        employer = rs.getString("employer");
                        industry = rs.getString("industry");
                        role = rs.getString("role");
                        salary = rs.getString("salary");
                        exp = rs.getString("exp");
                    }
                    sql = "select * from desiredjob where username='" + username + "'";
                    rs = st.executeQuery(sql);
                    if (rs.next()) {
                        des_industry = rs.getString("industry");
                        des_fun_area = rs.getString("fun_area");
                        des_salary = rs.getString("salary");
                        des_keyskill = rs.getString("keyskill");
                    }
                    sql = "select * from resume where username='" + username + "'";
                    rs = st.executeQuery(sql);
                    if (rs.next()) {
                        if (rs.getString("keyskill") != null) {
                            res_keyskill = rs.getString("keyskill");
                        }
                        if (rs.getString("title") != null) {
                            res_title = rs.getString("title");
                        }
                        if (rs.getString("textresume") != null) {
                            resume_text = rs.getString("textresume");
                        }


                    }

                    sql = "select * from education where username='" + username + "'";
                    rs = st.executeQuery(sql);

                    while (rs.next()) {
                        if (rs.getString("type").equals("1")) {
                            course10 = rs.getString("course");
                            uni10 = rs.getString("univ");
                            stream10 = rs.getString("stream");
                            year10 = rs.getString("year");
                            mark10 = rs.getString("marks");
                        } else if (rs.getString("type").equals("2")) {
                            course12 = rs.getString("course");
                            uni12 = rs.getString("univ");
                            stream12 = rs.getString("stream");
                            year12 = rs.getString("year");
                            mark12 = rs.getString("marks");
                        } else if (rs.getString("type").equals("3")) {
                            courseug = rs.getString("course");
                            uniug = rs.getString("univ");
                            streamug = rs.getString("stream");
                            yearug = rs.getString("year");
                            markug = rs.getString("marks");
                        } else if (rs.getString("type").equals("4")) {
                            coursepg = rs.getString("course");
                            unipg = rs.getString("univ");
                            streampg = rs.getString("stream");
                            yearpg = rs.getString("year");
                            markpg = rs.getString("marks");
                        }

                    }
                    sql = "select max(type)  from education where username='" + username + "'";
                    rs = st.executeQuery(sql);

                    if (rs.next()) {
                        maxedu = rs.getInt(1);
                    }

                    //out.println("max edu::" + maxedu);
                } catch (Exception e) {
                    out.println("Exception::" + e);
                }


%>
<style type="text/css">
    <!--
    .style2 {color: #0099FF}
    -->
</style>




<span class="mainheading_js">Edit/Update  Resume</span>
<div style="clear:both;"></div>
<span class="subheading"></span>
<span class="messagesred">
    <span class="error">    </span></span><br>
<script>
    $(document).ready(function(){
        $("#editresume").validationEngine();
    
        $('#Fresher').click(function() {
   
  
            $('#exp_dtls').hide(1000);
        });

        $('#experienced').click(function() {


            $('#exp_dtls').show(100);
        });
        $('#edudtl').change(function(){
      
            if($('#edudtl option:selected').val() == "1"){
                $("#edudtl10").show(1000);
                $("#edudtl12").hide(1000);
                $("#edudtlug").hide(1000);
                $("#edudtlpg").hide(1000);
            }
            else if($('#edudtl option:selected').val() == "2"){
                $("#edudtl10").show(1000);
                $("#edudtl12").show(1000);
                $("#edudtlug").hide(1000);
                $("#edudtlpg").hide(1000);
            }else if($('#edudtl option:selected').val() == "3"){
                $("#edudtl10").show(1000);
                $("#edudtl12").show(1000);
                $("#edudtlug").show(1000);
                $("#edudtlpg").hide(1000);
            }else if($('#edudtl option:selected').val() == "4"){
                $("#edudtl10").show(1000);
                $("#edudtl12").show(1000);
                $("#edudtlug").show(1000);
                $("#edudtlpg").show(1000);
            }else if($('#edudtl option:selected').val() == "0"){
                $("#edudtl10").hide(1000);
                $("#edudtl12").hide(1000);
                $("#edudtlug").hide(1000);
                $("#edudtlpg").hide(1000);
            }
        });
        

        if($('#edudtl option:selected').val() == "1"){
            $("#edudtl10").show(1000);
            $("#edudtl12").hide(1000);
            $("#edudtlug").hide(1000);
            $("#edudtlpg").hide(1000);
        }
        else if($('#edudtl option:selected').val() == "2"){
            $("#edudtl10").show(1000);
            $("#edudtl12").show(1000);
            $("#edudtlug").hide(1000);
            $("#edudtlpg").hide(1000);
        }else if($('#edudtl option:selected').val() == "3"){
            $("#edudtl10").show(1000);
            $("#edudtl12").show(1000);
            $("#edudtlug").show(1000);
            $("#edudtlpg").hide(1000);
        }else if($('#edudtl option:selected').val() == "4"){
            $("#edudtl10").show(1000);
            $("#edudtl12").show(1000);
            $("#edudtlug").show(1000);
            $("#edudtlpg").show(1000);
        }else if($('#edudtl option:selected').val() == "0"){
            $("#edudtl10").hide(1000);
            $("#edudtl12").hide(1000);
            $("#edudtlug").hide(1000);
            $("#edudtlpg").hide(1000);
        }
        if($('#Fresher').is(':checked')){
            $('#exp_dtls').hide(1000);
        }

    });

   
</script>

<form action="EditResume" id="editresume" name="editresume" method="post">
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
            <td height="19" colspan="2" align="center" valign="middle" class=mediumtxt><table width="100%" border="0" cellpadding="0" cellspacing="0" class="tblBorder">
                    <tr>
                        <td width="1214" colspan="2" align="left" class="bluebg"><table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl_bdr medium_font" >
                                <tr>
                                    <td height="20" colspan="6" align="left" class="sde_mnu_hdr_blue" style="padding-left:5px;"><strong><img style="margin-top:2px; margin-left:-2px;" src="../images/top_left.gif"; class="sde_mnu_img2"/>Resume Details </strong> </td>
                                </tr>
                                <tr>
                                    <td width="3%" height="22"  style="padding-left:5px;">&nbsp;</td>
                                    <td width="27%" height="28" align="left" valign="middle"  style="padding-left:5px;"><p ><span class='messagesred'>* </span>Resume Title</p></td>
                                    <td width="2%" align="left"  style="padding-left:2px;vertical-align:top">:</td>
                                    <td height="22" align="left"  style="padding-left:2px;" colspan="2"><input class="validate[required] textbox" id="resume_title" maxlength="70" size="35" name="resume_title" value="<%=res_title%>"/></td>
                                    <td width="3%" height="22" align="left"  style="padding-left:2px;">&nbsp;</td>
                                </tr>
                                <tr>
                                    <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                    <td height="28" align="left" valign="middle"  style="padding-left:5px;"><p ><span class='messagesred'>* </span>Key Skills</p></td>
                                    <td align="left"  style="padding-left:2px;">:</td>
                                    <td height="22" align="left"  style="padding-left:2px;" colspan="2">
                                        <input type="text" id="res_keyskill" name="res_keyskill" class="validate[required] textbox" value="<%=res_keyskill%>" /></td>
                                    <td height="22" align="left"  style="padding-left:2px;">&nbsp;</td>
                                </tr>
                                <tr>
                                    <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                    <td height="28" align="left" valign="top"  style="padding-left:5px;"><p ><span class='messagesred'>*</span>Copy Paste Your Resume Here</p></td>
                                    <td align="left"  style="padding-left:2px;vertical-align:top">:</td>
                                    <td height="22" align="left"  style="padding-left:2px;" colspan="2">
                                        <textarea id="wysiwyg" class="validate[required,minSize[500],maxSize[2500]] textbox"  name="restxt" style="width:320px; height:200px;"><%=resume_text%></textarea></td>
                                    <td height="22" align="left"  style="padding-left:2px;">&nbsp;</td>
                                </tr>


                                <tr>
                                    <td>&nbsp;</td>
                                </tr>
                            </table></td>
                    </tr>

                </table></td>
        </tr>

        <tr>
            <td colspan=2 height=20></td>
        </tr>

        <tr>
            <td colspan="2" class=mediumtxt><table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl_bdr medium_font" >
                    <tr>
                        <td height="20" colspan="6" align="left" class="sde_mnu_hdr_blue" style="padding-left:5px;"><strong><img style="margin-top:2px; margin-left:-2px;" src="../images/top_left.gif"; class="sde_mnu_img2"/>Desired Employment Details</strong> </td>
                    </tr>
                    <tr>
                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                        <td height="28" align="left" valign="middle"  style="padding-left:5px;"><p ><span class='messagesred'>* </span>Desired Key Skill</p></td>
                        <td align="left"  style="padding-left:2px;">&nbsp;</td>
                        <td height="22" align="left"  style="padding-left:2px;" colspan="2">
                            <input type="text" name="des_keyskill" id="des_keyskill" class="validate[required]" value="<%=des_keyskill%>">
                        </td>
                        <td height="22" align="left"  style="padding-left:2px;">&nbsp;</td>
                    </tr>
                    <tr>
                        <td width="2%" height="22"  style="padding-left:5px;">&nbsp;</td>
                        <td width="27%" height="28" align="left" valign="middle"  style="padding-left:5px;"><p ><span class='messagesred'>* </span>Desired Industry </p></td>
                        <td width="2%" align="left"  style="padding-left:2px;">&nbsp;</td>
                        <td height="22" align="left"  style="padding-left:2px;" colspan="2"><select name="desired_ind" size="1" class="listmenu" id="desired_ind" style="width:200px" onchange="showsubcatdes(this.value)">
                                <option value="<%=des_industry%>" selected="selected" ><%=des_industry%></option>
                                <option value="Accounting-Tax/Consulting" >Accounting-Tax/Consulting</option>
                                <option value="Architecture Interior Design" >Architecture Interior Design</option>
                                <option value="Automobiles" >Automobiles</option>
                                <option value="Banking/Financial" >Banking/Financial</option>
                                <option value="Biotech/Pharma" >Biotech/Pharma</option>
                                <option value="BPO/KPO" >BPO/KPO</option>
                                <option value="Bussiness management" >Bussiness management</option>
                                <option value="Construction/Engineering" >Construction/Engineering</option>
                                <option value="Entertainment/Media" >Entertainment/Media</option>
                                <option value="Graphic / Web Design" >Graphic / Web Design</option>
                                <option value="IT Hardware/Telecom" >IT Hardware/Telecom</option>
                                <option value="IT/Software Services" >IT/Software Services</option>
                                <option value="Software Development &amp; Sales" >Software Development &amp; Sales</option>
                                <option value="Supply Chain/Purchase" >Supply Chain/Purchase</option>
                                <option value="na" >na</option>
                            </select></td>
                        <td width="3%" height="22" align="left"  style="padding-left:2px;">&nbsp;</td>
                    </tr>
                    <tr>
                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                        <td height="28" align="left" valign="middle"  style="padding-left:5px;"><p ><span class='messagesred'>* </span>Desired Functional Area</p></td>
                        <td align="left"  style="padding-left:2px;">&nbsp;</td>
                        <td height="22" align="left"  style="padding-left:2px;" colspan="2"><select name="desired_fa" size="1" class="listmenu" id="desired_fa" style="width:200px">
                                <option value="<%=des_fun_area%>" selected="selected" ><%=des_fun_area%></option>
                                <option value="Accountant" >Accountant</option>
                                <option value="Accounting/Tax/Company Secretary/Audit" >Accounting/Tax/Company Secretary/Audit</option>
                                <option value="Accounts / Finance / Tax / CS / Audit" >Accounts / Finance / Tax / CS / Audit </option>
                                <option value="Accounts / Finance / Tax / CS / Auditing" >Accounts / Finance / Tax / CS / Auditing</option>
                                <option value="Architecture" >Architecture</option>
                                <option value="Architecture &amp; Interior Design" >Architecture &amp; Interior Design</option>
                                <option value="Automotive Tech" >Automotive Tech</option>
                                <option value="Banking / Insurance" >Banking / Insurance </option>
                                <option value="Clerks" >Clerks</option>
                                <option value="Content / Journalism" >Content / Journalism </option>
                                <option value="Designer manager" >Designer manager</option>
                                <option value="Freshers / Trainee Jobs" >Freshers / Trainee Jobs</option>
                                <option value="Freshers, Trainee Jobs" >Freshers, Trainee Jobs </option>
                                <option value="Graphics" >Graphics</option>
                                <option value="Hardware" >Hardware</option>
                                <option value="HR / Administration / IR" >HR / Administration / IR </option>
                                <option value="HR / Administrative / IR" >HR / Administrative / IR </option>
                                <option value="HR Manager" >HR Manager</option>
                                <option value="Hr Representatives" >Hr Representatives</option>
                                <option value="HR Trainers" >HR Trainers</option>
                                <option value="Interior Decorater" >Interior Decorater</option>
                                <option value="IT Software - DBA / Datawarehousing">IT Software - DBA / Datawarehousing </option>
                                <option value="IT Software - System Programming" >IT Software - System Programming</option>
                                <option value="IT Software - Systems / EDP / MIS" >IT Software - Systems / EDP / MIS </option>
                                <option value="IT Software-Mainframe" >IT Software-Mainframe</option>
                                <option value="J2ee" >J2ee</option>
                                <option value="kpo jobs finance" >kpo jobs finance</option>
                                <option value="Ledger maintainence" >Ledger maintainence</option>
                                <option value="Marketing / Advertising" >Marketing / Advertising</option>
                                <option value="Marketing / Advertising / MR / PR" >Marketing / Advertising / MR / PR </option>
                                <option value="Marketing / Advertising / MR / PR" >Marketing / Advertising / MR / PR </option>
                                <option value="Marketing / Advertisings" >Marketing / Advertisings </option>
                                <option value="pharma kpo jobs" >pharma kpo jobs</option>
                                <option value="Production / Maintenance / Quality" >Production / Maintenance / Quality </option>
                                <option value="Productions / Maintenance / Quality" >Productions / Maintenance / Quality </option>
                                <option value="Purchase / Logistics / Supply Chain" >Purchase / Logistics / Supply Chain </option>
                                <option value="Purchases / Logistic / Supply Chain" >Purchases / Logistic / Supply Chain</option>
                                <option value="Sales / BD" >Sales / BD </option>
                                <option value="Software" >Software</option>
                                <option value="Staff Manager" >Staff Manager</option>
                                <option value="Supervisor" >Supervisor</option>
                                <option value="Supplychain" >Supplychain</option>
                                <option value="Surveyor" >Surveyor</option>
                                <option value="test" >test</option>
                                <option value="Top Management- IT Jobs" >Top Management- IT Jobs </option>
                                <option value="Top Management- Non IT Jobs" >Top Management- Non IT Jobs </option>
                                <option value="Web / Graphic Design / Visualiser" >Web / Graphic Design / Visualiser </option>
                                <option value="Web Application" >Web Application</option>
                                <option value="na" >NA</option>
                                <option value="Other" >Other</option>
                            </select></td>
                        <td height="22" align="left"  style="padding-left:2px;">&nbsp;</td>
                    </tr>
                    <tr>
                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                        <td height="28" align="left" valign="middle"  style="padding-left:5px;"><p ><span class='messagesred'>*</span>Desired Salary </p></td>
                        <td align="left"  style="padding-left:2px;">&nbsp;</td>
                        <td height="22" align="left"  style="padding-left:2px;" colspan="2">
                            <input name="desired_salary" type="text"  id="desired_salary" class="validate[required,custom[number],min[0]]" maxlength="10" size="10"  value="<%=des_salary%>"/>
                            Anually                            in INR </td>
                        <td height="22" align="left"  style="padding-left:2px;">&nbsp;</td>
                    </tr>

                    <tr>
                        <td>&nbsp;</td>
                    </tr>
                </table></td>
        </tr>
        <tr>
            <td colspan="2" align="center" valign="middle" class=mediumtxt>&nbsp;</td>
        </tr>

        <tr>
            <td colspan="2" ><table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl_bdr medium_font" >
                    <tr>
                        <td height="20" colspan="5" align="left" class="sde_mnu_hdr_blue" style="padding-left:5px;"><strong><img style="margin-top:2px; margin-left:-2px;" src="../images/top_left.gif"; class="sde_mnu_img2"/>Professional Experience</strong> </td>
                    </tr>
                    <tr>
                        <td width="2%" height="28"  style="padding-left:5px;">&nbsp;</td>
                        <td width="31%" height="28" align="left" valign="middle"  style="padding-left:5px;">
                            <span class='messagesred'>*</span>Indicate Fresher or Experienced</td>
                            <%
                                if (Integer.parseInt(exp) <= 0) {

                            %>
                        <td width="22%" align="left" valign="middle"  style="padding-left:5px;">

                            <label> <input type="radio" name="radio" id="Fresher" checked value="Fresher" class="radio"/>
                                Fresher</label></td>
                        <td width="42%" align="left" valign="middle"  style="padding-left:5px;"><label>
                                <input type="radio" name="radio" id="experienced" value="experienced" class="radio"/>
                                Experinced</label></td>
                                <%} else {%>

                        <td width="22%" align="left" valign="middle"  style="padding-left:5px;">

                            <label> <input type="radio" name="radio" id="Fresher"  value="Fresher" class="radio"/>
                                Fresher</label></td>
                        <td width="42%" align="left" valign="middle"  style="padding-left:5px;"><label>
                                <input type="radio" name="radio" id="experienced" checked value="experienced" class="radio"/>
                                Experinced</label></td>

                        <%}%>
                        <td width="3%" height="28" align="left"  style="padding-left:2px;">&nbsp;</td>
                    </tr>
                    <tr>
                        <td height="28"  style="padding-left:5px;">&nbsp;</td>
                        <td height="28" colspan="3" align="left" valign="middle"  style="padding-left:5px;"><table width="100%" border="0" id="exp_dtls">
                                <tr>
                                    <td colspan="3"><span class="style2"></span><span class="style2"></span><span class="style2"><strong> Employment Details :</strong></span></td>
                                </tr>
                                <tr>
                                    <td><p ><span class='messagesred'>*</span>  Employer </p></td>
                                    <td>&nbsp;</td>
                                    <td><span style="padding-left:2px;">
                                            <input name="exp__co" type="text" class="textbox" id="exp__co" maxlength="100" size="30" value="<%=employer%>"/>
                                        </span></td>
                                </tr>
                                <tr>
                                    <td><p ><span class='messagesred'>*</span>  Industry </p></td>
                                    <td>&nbsp;</td>
                                    <td><span style="padding-left:2px;">
                                            <select name="_ind" size="1" class="listmenu" id="_ind" style="width:200px">
                                                <option value="<%=industry%>" selected="selected" ><%=industry%></option>
                                                <option value="">Select Industry </option>
                                                <option value="Accounting-Tax/Consulting" >Accounting-Tax/Consulting</option>
                                                <option value="Architecture Interior Design" >Architecture Interior Design</option>
                                                <option value="Automobiles" >Automobiles</option>
                                                <option value="Banking/Financial" >Banking/Financial</option>
                                                <option value="Biotech/Pharma" >Biotech/Pharma</option>
                                                <option value="BPO/KPO" >BPO/KPO</option>
                                                <option value="Bussiness management" >Bussiness management</option>
                                                <option value="Construction/Engineering" >Construction/Engineering</option>
                                                <option value="Entertainment/Media" >Entertainment/Media</option>
                                                <option value="Graphic / Web Design" >Graphic / Web Design</option>
                                                <option value="IT Hardware/Telecom" >IT Hardware/Telecom</option>
                                                <option value="IT/Software Services">IT/Software Services</option>
                                                <option value="Software Development &amp; Sales" >Software Development &amp; Sales</option>
                                                <option value="Supply Chain/Purchase" >Supply Chain/Purchase</option>
                                                <option value="na" >na</option>
                                                <option value="Other" >Other</option>
                                            </select>
                                        </span></td>
                                </tr>
                                <tr>
                                    <td><p ><span class='messagesred'>*</span>  Job Role</p></td>
                                    <td>&nbsp;</td>
                                    <td><span style="padding-left:2px;">
                                            <input name="exp__jobrole" type="text" class="textbox" id="exp__jobrole" maxlength="25" size="30" value="<%=role%>"/>
                                        </span></td>
                                </tr>
                                <tr>
                                    <td><p ><span class='messagesred'>*</span>  Salary </p></td>
                                    <td>&nbsp;</td>
                                    <td><span style="padding-left:2px;">
                                            <input name="current_salary" type="text" class="validate[custom[number],min[0]]textbox" id="_salary" maxlength="10" size="10" value="<%=salary%>"/>
                                            in  INR </span></td>
                                </tr>
                                <tr>
                                    <td><p><span class='messagesred'>*</span>Total Experience</p></td>
                                    <td>&nbsp;</td>
                                    <td><span style="padding-left:2px;">
                                            <select name="tot_exp_years" id="tot_exp_years">
                                                <option value="<%=exp%>" selected="selected" ><%=exp%></option>
                                                <option value="0" >0</option>
                                                <option value="1" >1</option>
                                                <option value="2" >2</option>
                                                <option value="3" >3</option>
                                                <option value="4" >4</option>
                                                <option value="5" >5</option>
                                                <option value="6" >6</option>
                                                <option value="7" >7</option>
                                                <option value="8" >8</option>
                                                <option value="9" >9</option>
                                                <option value="10" >10</option>
                                                <option value="11" >11</option>
                                                <option value="12" >12</option>
                                                <option value="13" >13</option>
                                                <option value="14" >14</option>
                                                <option value="15" >15</option>
                                                <option value="16" >16</option>
                                                <option value="17" >17</option>
                                                <option value="18" >18</option>
                                                <option value="19" >19</option>
                                                <option value="20" >20</option>
                                                <option value="21" >21</option>
                                                <option value="22" >22</option>
                                                <option value="23" >23</option>
                                                <option value="24" >24</option>
                                                <option value="25" >25</option>
                                                <option value="26" >26</option>
                                                <option value="27" >27</option>
                                                <option value="28" >28</option>
                                                <option value="29" >29</option>
                                                <option value="30" >30</option>
                                                <option value="31" >31</option>
                                                <option value="32" >32</option>
                                                <option value="33" >33</option>
                                                <option value="34" >34</option>
                                                <option value="35" >35</option>
                                                <option value="36" >36</option>
                                                <option value="37" >37</option>
                                                <option value="38" >38</option>
                                                <option value="39" >39</option>
                                                <option value="40" >40</option>
                                                <option value="41" >41</option>
                                                <option value="42" >42</option>
                                                <option value="43" >43</option>
                                                <option value="44" >44</option>
                                                <option value="45" >45</option>
                                            </select>
                                            Yrs. </span></td>
                                </tr>
                            </table></td>
                        <td height="28" align="left"  style="padding-left:2px;">&nbsp;</td>
                    </tr>


                    <tr>
                        <td>&nbsp;</td>
                    </tr>
                </table></td>
        </tr>
        <tr>
            <td width="366" >&nbsp;</td>
            <td width="592" >&nbsp;</td>
        </tr>
        <tr>
            <td colspan="2" ><table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl_bdr medium_font">
                    <tr>
                        <td height="20" colspan="4" align="left" class="sde_mnu_hdr_blue" style="padding-left:5px;"><strong><img style="margin-top:2px; margin-left:-2px;" src="../images/top_left.gif"; class="sde_mnu_img2"/>Academic   Details </strong> </td>
                    </tr>
                    <tr>
                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                        <td height="22" align="left"  style="padding-left:2px;" width="25%">Highest Education</td>
                        <td height="22" align="left"  style="padding-left:2px;" width="69%">
                            <select name="edudtl" id="edudtl">
                                <%if (maxedu == 0) {%>
                                <option value="0" selected>==select==</option>
                                <%}%>
                                <%if (maxedu == 1) {%>
                                <option value="1" selected>10 th</option>
                                <%} else {%>
                                <option value="1">10 th</option>
                                <%}%>

                                <%if (maxedu == 2) {%>
                                <option value="2" selected>12 th</option>
                                <%} else {%>
                                <option value="2">12 th</option>
                                <%}%>

                                <%if (maxedu == 3) {%>
                                <option value="3" selected>Under Graduate</option>
                                <%} else {%>
                                <option value="3">Under Graduate</option>
                                <%}%>

                                <%if (maxedu == 4) {%>
                                <option value="4" selected>Post Graduate</option>
                                <%} else {%>
                                <option value="4">Post Graduate</option>
                                <%}%>


                            </select>
                        </td>
                        <td height="22" align="left"  style="padding-left:2px;">&nbsp;</td>
                    </tr>
                    <tr>
                        <td height="22"  style="padding-left:5px;" width="3%">&nbsp;</td>
                        <td height="22" align="left"  style="padding-left:2px;" colspan="2"><table width="100%" border="0" cellspacing="1" style="text-align:center" class="tbl_bdr medium_font">
                                <tr class="sde_mnu_hdr_blue" style="background-color: lightskyblue">
                                    <td width="17%">course</td>
                                    <td width="36%">university/school</td>
                                    <td width="18%">stream</td>
                                    <td width="11%">year</td>
                                    <td width="18%">% Marks </td>
                                </tr>
                                <tr id="edudtl10">
                                    <td><select name="course10" id="course10" style="width:150px">
                                            <option value="<%=course10%>" selected="selected" ><%=course10%></option>
                                            <option value="10">10</option>
                                        </select></td>
                                    <td><input type="text" name="uni10" id="uni10" width="200px" value="<%=uni10%>" style="width:150px" /></td>
                                    <td><input type="text" name="stream10" id="stream10" value="<%=stream10%>" style="width:150px" /></td>
                                    <td><select name="year10" id="year10" style="width:70px">
                                            <%
                                                if (year10.equals("")) {
                                                    out.print("<option value=\"\" selected=\"selected\"></option>");
                                                }
                                                for (int i = 1933; i < 2016; i++) {
                                                    if (!year10.equals("") && i == Integer.parseInt(year10)) {
                                                        out.print("<option value=\"" + i + "\" selected=\"selected\">" + i + "</option>");
                                                    } else {
                                                        out.print("<option value=\"" + i + "\">" + i + "</option>");
                                                    }
                                                }

                                            %>
                                        </select></td>
                                    <td>
                                        <input type="text" name="mark10" id="mark10" class="validate[custom[number],min[0],max[100]]" style="width:50px" value="<%=mark10%>" />
                                        %</td>
                                </tr>
                                <tr id="edudtl12">
                                    <td><select name="course12" id="course12" style="width:150px">
                                            <option value="<%=course12%>" selected="selected" ><%=course12%></option>
                                            <option value="12">12</option>
                                        </select></td>
                                    <td><input type="text" name="uni12" id="uni12" width="200px" value="<%=uni12%>" style="width:150px" /></td>
                                    <td><input type="text" name="stream12" id="stream12"  value="<%=stream12%>" style="width:150px" /></td>
                                    <td><select name="year12" id="year12"  style="width:70px">
                                            <%
                                                if (year12.equals("")) {
                                                    out.print("<option value=\"\" selected=\"selected\"></option>");
                                                }
                                                for (int i = 1933; i < 2016; i++) {
                                                    if (!year12.equals("") && i == Integer.parseInt(year12)) {
                                                        out.print("<option value=\"" + i + "\" selected=\"selected\">" + i + "</option>");
                                                    } else {
                                                        out.print("<option value=\"" + i + "\">" + i + "</option>");
                                                    }
                                                }

                                            %>
                                        </select></td>
                                    <td>
                                        <input type="text" name="mark12" id="mark12" class="validate[custom[number],min[0],max[100]]" style="width:50px"  value="<%=mark12%>" />
                                        %</td>
                                </tr>
                                <tr id="edudtlug">
                                    <td><select name="courseug" id="courseug" style="width:150px">
                                            <option value="<%=courseug%>" selected="selected" ><%=courseug%></option>
                                            <%
                                                rs1 = st1.executeQuery("SELECT course FROM course c where type='ug'");

                                                while (rs1.next()) {
                                                    out.print("<option value=\"" + rs1.getString("course") + "\">" + rs1.getString("course") + "</option>");
                                                }

                                            %>
                                        </select></td>
                                    <td><input type="text" name="uniug" id="uniug" width="200px" value="<%=uniug%>" style="width:150px"/></td>
                                    <td><input type="text" name="streamug" id="streamug"  value="<%=streamug%>" style="width:150px"/></td>
                                    <td><select name="yearug" id="yearug"  style="width:70px">
                                            <%
                                                if (yearug.equals("")) {
                                                    out.print("<option value=\"\" selected=\"selected\"></option>");
                                                }
                                                for (int i = 1933; i < 2016; i++) {
                                                    if (!yearug.equals("") && i == Integer.parseInt(yearug)) {
                                                        out.print("<option value=\"" + i + "\" selected=\"selected\">" + i + "</option>");
                                                    } else {
                                                        out.print("<option value=\"" + i + "\">" + i + "</option>");
                                                    }
                                                }

                                            %>
                                        </select></td>
                                    <td><input type="text" name="markug" id="markug" class="validate[custom[number],min[0],max[100]]" style="width:50px"  value="<%=markug%>" />
                                        %</td>
                                </tr>
                                <tr id="edudtlpg">
                                    <td><select name="coursepg" id="coursepg" style="width:150px">
                                            <option value="<%=coursepg%>" selected="selected" ><%=coursepg%></option>
                                            <%
                                                rs1 = st1.executeQuery("SELECT course FROM course c where type='pg'");

                                                while (rs1.next()) {
                                                    out.print("<option value=\"" + rs1.getString("course") + "\">" + rs1.getString("course") + "</option>");
                                                }

                                            %>
                                        </select></td>
                                    <td><input type="text" name="unipg" id="unipg" width="200px" value="<%=unipg%>" style="width:150px" /></td>
                                    <td><label>
                                            <input type="text" name="streampg" id="streampg"  value="<%=streampg%>" style="width:150px" />
                                        </label></td>
                                    <td><select name="yearpg" id="yearpg"  style="width:70px">
                                            <%
                                                if (yearpg.equals("")) {
                                                    out.print("<option value=\"\" selected=\"selected\"></option>");
                                                }
                                                for (int i = 1933; i < 2016; i++) {
                                                    if (!yearpg.equals("") && i == Integer.parseInt(yearpg)) {
                                                        out.print("<option value=\"" + i + "\" selected=\"selected\">" + i + "</option>");
                                                    } else {
                                                        out.print("<option value=\"" + i + "\">" + i + "</option>");
                                                    }
                                                }

                                            %>
                                        </select></td>
                                    <td><input type="text" name="markpg" id="markpg" class="validate[custom[number],min[0],max[100]]" style="width:50px"  value="<%=markpg%>" />
                                        %</td>
                                </tr>
                                <tr class="sde_mnu_hdr_blue" style="background-color: lightskyblue">
                                    <td>&nbsp;</td>
                                    <td>&nbsp;</td>
                                    <td>&nbsp;</td>
                                    <td>&nbsp;</td>
                                    <td>&nbsp;</td>
                                </tr>
                            </table></td>
                        <td height="22" align="left"  style="padding-left:2px;" width="3%">&nbsp;</td>
                    </tr>
                    <tr>
                        <td>&nbsp;</td>
                    </tr>
                </table></td>
        </tr>
        <tr>
            <td colspan="2" align="center" valign="middle" ></td>
        </tr>
        <tr>
            <td >&nbsp;</td>
            <td >&nbsp;</td>
        </tr>

        <tr>
            <td >&nbsp;</td>
            <td  style="padding-left:15px; padding-top:5px;"><input name="Submit2" type="submit" class="button2" value="Post Resume"/></td>
        </tr>
        <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
    </table>
</form>
<%} catch (Exception e) {
                out.println("<font color=\"black\">" + e + "</font>");
            }%>
<%@include file="footer.jsp" %>